Re: pg_dump restore as transaction? - Mailing list pgsql-general

From Owen Hartnett
Subject Re: pg_dump restore as transaction?
Date
Msg-id p0624080fc559d3508b06@[192.168.0.107]
Whole thread Raw
In response to Re: pg_dump restore as transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At 12:37 PM -0500 12/1/08, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>>  If my perusal of the sql generated by pg_dump is correct, then it
>>  doesn't appear that it's wrapped in a transaction, and thus might be
>>  able to only complete a partial restore?
>
>That's correct, and intentional.  You can use pg_restore's -1 switch
>or add begin/end manually if you don't want it to work that way.
>
>            regards, tom lane

Thanks to everybody for their help.  You guys are great.

-Owen

pgsql-general by date:

Previous
From: Peter Billen
Date:
Subject: Re: pg_dump restore as transaction?
Next
From: Sebastian Tennant
Date:
Subject: Re: Detecting changes to certain fields in 'before update' trigger functions